<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>today Queen</title>

<link rel="stylesheet" href="style/style_gioithieu.css" type="text/css" />
<script src="Scripts/swfobject_modified.js" type="text/javascript"></script>
</head>

<body id="body" >
	<div id="header">
    	<div id="head">
    		<div id="marquee">
            	<marquee ><img src="images/marquee_02.png" alt="lien he"/></marquee>
             </div>
             <div id="button">
                <a href="dangky.php"><img src="images/btn1_04.png" border="0"/></a>
                <a href="dangnhap.php"><img src="images/btn1_05.png" border="0"/></a>
                <a href="giohang.php"><img src="images/btn1_06.png" border="0"/></a>
              </div>
    	</div>
       <div id="header_menu">
        	<ul>
            	<li><a href="index.php">Trang Chủ</a></li>
                <li><a href="gioithieu.php">Giới Thiệu</a></li>
                <li><a href="thanhtoan.php">Thanh Toán</a></li>
                <li><a href="cachbaoquanhoa.php">Cách Bảo Quản Hoa</a></li>
                <li><a href="lienhe.php">Liên Hệ</a></li>
            </ul>
        </div>
    </div>
 <!--noi dung-->
 	<div id="content">
    	<div id="content1">
        </div>
    	<div id="content_chinh">
       <!-- //query-->
        	<div id="content_Jquery">
            
			  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="730" height="209" id="FlashID" title="Today Queen">
				  <param name="movie" value="swf/banner.swf" />
				  <param name="quality" value="high" />
				  <param name="wmode" value="opaque" />
				  <param name="swfversion" value="6.0.65.0" />
				  <!-- This param tag prompts users with Flash Player 6.0 r65 and higher to download the latest version of Flash Player. Delete it if you don’t want users to see the prompt. -->
				  <param name="expressinstall" value="Scripts/expressInstall.swf" />
				  <!-- Next object tag is for non-IE browsers. So hide it from IE using IECC. -->
				  <!--[if !IE]>-->
				  <object type="application/x-shockwave-flash" data="swf/banner.swf" width="730" height="209">
				    <!--<![endif]-->
				    <param name="quality" value="high" />
				    <param name="wmode" value="opaque" />
				    <param name="swfversion" value="6.0.65.0" />
				    <param name="expressinstall" value="Scripts/expressInstall.swf" />
				    <!-- The browser displays the following alternative content for users with Flash Player 6.0 and older. -->
				    <div>
				      <h4>Content on this page requires a newer version of Adobe Flash Player.</h4>
				      <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" width="112" height="33" /></a></p>
			        </div>
				    <!--[if !IE]>-->
			    </object>
				  <!--<![endif]-->
			  </object>
<!--ket thuc query-->
      </div>
        	<div id="content_menu">
            	<ul>
                	<li><a href="bohoatuoi.php"><img src="images/menutrai_05.png" border="0px"/></a></li>
                    <li><a href="giohoatuoi.php"><img src="images/menutrai_07.png" border="0px"/></a></li>
                    <li><a href="binhhoatuoi.php"><img src="images/menutrai_08.png" border="0px"/></a></li>
                    <li><a href="hoatinhyeu.php"><img src="images/menutrai_09.png" border="0px"/></a></li>
                    <li><a href="hoakhaitruong.php"><img src="images/menutrai_10.png" border="0px"/></a></li>
                    <li><a href="hoachiabuon.php"><img src="images/menutrai_11.png" border="0px"/></a></li>
                </ul>
            </div>
            <div id="content_noidung">
				<div id="content_thanhmuc">
         	<h3>Hoa Today Queen</h3>
         </div>
	<?php
include("connect.php");// thực hiện kết nối đến CSDL
$page = isset ( $_GET["page"] ) ? intval ( $_GET["page"] ) : 1; 
$rows_per_page = 1; 
$pagesize=9;

$sql_query = ("select * from policy"); 
$result = mysql_query($sql_query,$connect) or die ("khong the thuc hien cau truy van");
$num_rows = mysql_num_rows($result);

$number_of_page = ceil( $num_rows / $rows_per_page ); 



//hien thi du lieu
echo "<table border = '0' width='100%/3' >";



$offset = ($page -1)*$rows_per_page;
$sql = "select * from policy limit $offset ,$rows_per_page";
$rs = mysql_query($sql,$connect);

while($row = mysql_fetch_array($rs)){
echo "<TR>";


	
echo "<td>";
 
echo "<IMG src='images/".$row['status']."'>"."<IMG src='images/".$row['flag']."'>  ";
echo "<p>".$row['title'] ."<p>".$row['content']."<p>".$row['date_post']."</td>";



echo "</TR>";

}

echo "</table>";

if ( $number_of_page > 1 ) 
{ 
$list_page = " <td> Trang: </td>"; 
for ( $i = 1; $i <= $number_of_page; $i++ ) 
	{ 
		if ( $i == $page ) 
		{ 
			$list_page .= " <td>[ <b>{$i}</b> ]</td> "; 
		} else 
				{ 
				$list_page .= "<td><a href='gioithieu.php?page={$i}'> {$i} </a></td>"; 
				} 
	} 
}
echo  $list_page; 
?>
			
                        
            </div> <!--end nd chung-->
        </div><!--end nd chinh-->
       
    </div> <!--end content-->
     
     <div id="footer"> 
     </div> <!--footer-->
<script type="text/javascript">
<!--
swfobject.registerObject("FlashID");
//-->
     </script>
     <img src="data/products/<?=$rs["pd_image"]?>" />
</body>
</html>
